2015-03-12 - 17813 - Enhancement - Add Sales Order Number to Open Orders #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
17813 - Add Sales Order Number to Open Orders
Purpose
Add Sales Order Number to OLAP Analysis Queries for Open Orders.
Admin Info
Purpose
|
Need to add Sales order Number to OLAP Analysis Queries for Open Orders.
|
Requested By
|
Irene Yeung
|
Spec Created By
|
Naveen.G
|
Spec Created Date
|
03-12-2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VMP_OOCON_Q002, VMP_OOCON_Q003, VEA_OOCON_Q002,
VJA_OOCON_Q002, VEM_OOCON_Q002, VEJ_OOCON_Q002
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
03
|
3
|
Development/ Config
|
02
|
4
|
Unit test in DEV
|
01
|
5
|
Unit test in QUA
|
01
|
6
|
Transports
|
01
|
|
TOTAL
|
08
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Mark.G:
We would like to have the Sales Order # field added to each of the open orders analysis queries listed below. Please let me know who this work will be assigned to so that I can provide them with a recap ticket. We would like this completed as soon as possible and have it moved into production by end of day.
VMP_OOCON_Q002
VMP_OOCON_Q003
VEA_OOCON_Q002
VJA_OOCON_Q002
VEM_OOCON_Q002
VEJ_OOCON_Q002
In Scope:
Add Sales order number to above listed Analysis BEx queries.
Out of Scope:
None
Solution Summary
1. Need to create a open transport request in BPD(BW 7.3 Development).
2. Need to add sales order number in free characteristics panel in the BEx Queries specified above.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the Sales order number is added to the BEx Queries specified.
|
Sales Order number should be added to all the BEx Queries specified.
|
2
|
Check if all the objects are collected into the transport request.
|
All the objects must be collected into the transport request.
|
Solution Details
1. Need to create a open transport request in BPD(BW 7.3 Development).
2. Need to add sales order number in free characteristics panel in the BEx Queries VMP_OOCON_Q002,
VMP_OOCON_Q003, VEA_OOCON_Q002, VJA_OOCON_Q002, VEM_OOCON_Q002 and VEJ_OOCON_Q002.
Issues
None